CREATE TABLE [dbo].[JOL_Admin]
(
[fdAdminNo] [int] NOT NULL IDENTITY(1, 1),
[fdAdminLoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__65E11278] DEFAULT (NULL),
[fdAdminPwd] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__66D536B1] DEFAULT (NULL),
[fdAdminName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__67C95AEA] DEFAULT (NULL),
[fdAdminMobile] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__68BD7F23] DEFAULT (NULL),
[fdAdminEmail] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__69B1A35C] DEFAULT (NULL),
[fdAdminPhone] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__6AA5C795] DEFAULT (NULL),
[fdAdminStatus] [bit] NULL CONSTRAINT [DF__JOL_Admin__fdAdm__6B99EBCE] DEFAULT ((0)),
[fdAdminAddTime] [datetime] NULL CONSTRAINT [DF__JOL_Admin__fdAdm__6C8E1007] DEFAULT (NULL),
[fdAdminAddLoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__6D823440] DEFAULT (NULL),
[fdAdminUpdateTime] [datetime] NULL CONSTRAINT [DF__JOL_Admin__fdAdm__6E765879] DEFAULT (NULL),
[fdAdminUpdateLoginID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL CONSTRAINT [DF__JOL_Admin__fdAdm__6F6A7CB2] DEFAULT (NULL)
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Admin] ADD CONSTRAINT [PK__JOL_Admin__63F8CA06] PRIMARY KEY CLUSTERED  ([fdAdminNo]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[JOL_Admin] ADD CONSTRAINT [UQ__JOL_Admin__64ECEE3F] UNIQUE NONCLUSTERED  ([fdAdminLoginID]) ON [PRIMARY]
GO
